begin tran
declare @new_sku nvarchar(20), @old_sku nvarchar(20) 

--update pos_st_ctrl set sku = @new_sku where sku = @old_sku
--update pos_bin_stock set sku = @new_sku where sku = @old_sku

update pos_return_dtl set sku = @new_sku where sku = @old_sku
update pos_return_constr set sku = @new_sku where sku = @old_sku
update pos_return_rec set sku = @new_sku where sku = @old_sku
update pos_sales_dtl set sku = @new_sku where sku = @old_sku
update pos_stk_constr set sku = @new_sku where sku = @old_sku
update pos_stk_item set sku = @new_sku where sku = @old_sku
update pos_stkform_dtl set sku = @new_sku where sku = @old_sku
update pos_stockin_constr set sku = @new_sku where sku = @old_sku
update pos_stockin_dtl set sku = @new_sku where sku = @old_sku
update pos_trx_in_dtl set sku = @new_sku where sku = @old_sku
update pos_trx_in_constr set sku = @new_sku where sku = @old_sku
update pos_trx_out_constr set sku = @new_sku where sku = @old_sku
update pos_trx_out_dtl set sku = @new_sku where sku = @old_sku
rollback tran